Magnum One

home *** CD-ROM | disk | FTP | other *** search

/ Magnum One / Magnum One (Mid-American Digital) (Disc Manufacturing).iso / d6 / kisbill.arc / KISBILL.EXE / KISBILL.DOC < prev next >

Wrap

Text File | 1990-04-22 | 117KB | 2,104 lines

╓────────────────────────────────────────────────────────────────────╖▓ ║ █░ █░ ███░ ▄█████░ █▄█████▄░ ███░ █░ █░ ║▓ ║ █░ █░ █░ ▄█░ █▀░ ██░ █░ █░ █░ ║▓ ║ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║▓ ║ ███░ █░ ▀█▄░ █░ ▄█░ █░ █░ █░ ║▓ ║ █░ █░ █░ ▀████▄░ ████████░ █░ █░ █░ ║▓ ║ █░ █░ █░ ▀█▄░ █░ ▀█░ █░ █░ █░ ║▓ ║ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║▓ ║ █░ █░ █░ ██░ █▄░ ██░ █░ █░ █░ ║▓ ║ █░ █░ ███░ █████▀░ █▀█████▀░ ███░ █████░ █████░ ║▓ ╙────────────────────────────────────────────────────────────────────╜▓ ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ Version 1.2 (1 Jan 1990) Keep It Simple Billing & Invoicing System A Product of TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║ ╚════════════════════════════════════════════════════════════════════════════╝ KISBILL - Keep It Simple Billing and Invoicing System Table of Contents Page Subject ──── ─────────────────────────────────────── 1....................Introduction 1....................Feature Highlights 1....................Copyright Notice 1....................Disclaimer 2....................Hardware Requirements 2....................Setup/Configuration/Defaults 3......................Color Monitor 3......................High Intensity Colors 3......................Printer Type 3......................Company Name and Address 3......................Invoice Numbers 3......................State Sales Tax 3......................Graph Settings 3....................MAIN MENU 4....................Help Screen 4....................Delete Invoice 4....................Recalculate Subtotal 5....................Editing Invoice Header Records (INVOICE.DBF) 5....................Editing Detail/Line Records DETAIL.DBF) 6....................Finding Items While Editing/Browsing 6....................Add/Create Invoice 7....................Refunds/Returns 8....................Graph, Last 12 Calendar Months Sales 10...................Printing Invoices 10...................Reports 10...................Printer Setup 11...................Sample Invoice 12...................Reports (& Label) Menu 12...................Report Forms 12...................Header Invoice Report (Date Range & Index Selection) 13...................Detail Invoice Report (Date Range & Index Selection) 13................... Example of the Detail Invoice Report 13...................Product/Item Listing 14................... Example of the Product/Item Report 14...................Detail Product/Item Movement With Date Range) 14................... Example of the Product/Item Movement Report 15...................Customers (Unique CUSNUM & NAME) 15................... Example of the Customers List 16...................Address and Mailing Labels 16................... Example of Address/Mailing Labels 17...................Folder Labels (CUSNUM, NAME) 17................... Example of Folder Labels 17...................Open Invoice Report (Date Range & Index Selection) KISBILL - Keep It Simple Billing and Invoicing System Table of Contents Continued... Page Subject ──── ─────────────────────────────────────── 18...................Miscellaneous Routines 18.....................APPEND FROM 20.....................BROWSE DATABASES 22.....................COPY (.DBF) TO 24.....................CREATE DATABASE 25.....................DELETE RECORDS 27.....................ERASE FILE 27.....................EXIT TO DOS 27.....................INDEX A DATABASE 29.....................LIST FIELDS 31.....................MODIFY DATABASE 32.....................PACK DATABASE 33.....................RECALL RECORDS 33.....................RUN (DOS COMMAND) 33.....................SIMPLE EDITOR 35.....................SORT DATABASE 36.....................TYPE (PRINT) FILE 37.....................ZAP DATABASE 39...................Order Form KISBILL - Keep It Simple Billing and Invoicing System Page: 1 KISBILL.EXE Copyright (c) 1989 TJS LAB KISBILL is a simple to use and operate billing and invoicing system. This product was produced to provide a means of billing a client or customer. Very little setup is required (ie: Your Company Name, and address). KISBILL utilizes 2 Dbase (tm) compatible databases which contain the invoice header and detail data. The detail database also serves as an inventory/lookup file for later invoices. KISBILL is also multi-user, able to operate on most of the PC based networks, ie: Novell (tm). A simple database management module is also included to provide you with additional means to modify, view or report on your data. Feature Highlights: Menu Driven A Simple DataBase Management System: Unlimited Users - Create databases Multiuser - Edit databases Sales Graph - Create simple reports Dbase (tm) compatible - Append files - Copy files - Simple Editor COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. No resale of any part of the source codes is authorized without the prior written consent of TJS LAB. The only exception to this rule is the making of backup copies of registered software disks. TJS LAB retains all rights to KISBILL software, documentation, and source codes. DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware and/or software systems as a result of using KISBILL. TJS LAB │ Messages Can Be Left Online At: P.O. Box 585366 │ 4409 Beaumont Drive │ Compuserve: 76367,1401 Orlando, Florida 32858-5366 │ GEnie: T.L.JOHNSON │ Voice Mail: (407) 291-3960 KISBILL - Keep It Simple Billing and Invoicing System Page: 2 ■ REQUIREMENTS IBM or Compatible CPU 640K memory ■ SETUP - Setup is made easier with KISBILL. It will create the necessary databases and other files it requires. KISBILL is capable of running on a floppy disk, however, you will be limited in the in number of invoice records. A hard disk is recommended. If you are going to use a hard disk, copy the contents of the KISBILL disk (or UnZip KISBILL.ZIP) onto it, into a directory of its own (ie: \KISBILL). On your initial 'run' through KISBILL, you will be prompted to verify and/or change the defaults and system configuration. The key item here is your company name and address. ┌──────────────────────────[ Setup Configuration ]────────────────────────────┐ │ Color: Y │ │ High Intensity: N │ │ Printer Type: HP (HP) HP Laser, or (ST) Standard │ │ Company Name: TJS LAB │ │ Address Line 1: Attn: Accounts Receivable │ │ Address Line 2: P.O. BOX 585366 │ │ City, State Zip: Orlando, Florida 32858-5366 │ │ Telephone: 407-291-3960 │ │ Last Invoice #: 999 │ │ Sales Tax: .060 │ │ Include ADJUST on Graph: N │ │ Include FREIGHT on Graph: N │ │ Include TAX on Graph: N │ └─────────────────────────────────────────────────────────────────────────────┘ - If you have a color monitor and wish to display colors, then select Y (YES), else select N (NO) for monochrome. The default is color, low intensity - If you have a color monitor and want high intensity colors, select Y for the high intensity. - The third option wants to know what type of printer you are using. The only difference between the two is that if you select the HP Laser option, you will be prompted to select the number of copies each time you print an invoice. Of course the HP Laser invoice is much prettier... KISBILL - Keep It Simple Billing and Invoicing System Page: 3 - Enter your company name, address and telephone number as you want it printed onto the invoice. - The invoice numbers start at this 'Last Invoice #' value + 1. The default is to have a first invoice number of '1'. - The next prompt is for the default sales tax. The default is 6% (as in Florida). At invoice time, the default is to charge taxes. - When the graph data is computed, the default is to sum the detail data. This may cause a problem because it will not be including adjustments, freight, and tax. If any of these 3 graph settings is set to 'Y', then the data will be summed from the invoice headers (INVOICE.DBF). ■ MAIN MENU After getting through the free 'advertising' and 'register me' screens you are presented with the MAIN MENU, ie: KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ TJS LAB, PO BOX 5366, ORLANDO FL 32858 (Version B1.2) │S M T W T F S │ Invoice: 1000 259.62 ├────────────────────┤ Customer Number: 1200 │ 1 2 3 4│ Date: 11/05/89 │ 5 6 7 8 9 10 11│ Name: HARPER BOOKS │12 13 14 15 16 17 18│ Attn: ACCOUNTS PAYABLE │19 20 21 22 23 24 25│ Phone: 393-5555 │26 27 28 29 30 │ Address1: │ │ City,State Zip: ORLANDO, FL34233-0393 └────────────────────┘ INVOICE NAME CUSNUM ──────────────────────╥────────────────────────────────╥─────────────────────── 1000 ║ HARPER BOOKS ║ 1200 1001 ║ EARL WOODS ║ 1201 1002 ║ YELLOW REEDS STORE ║ 1202 1003 ║ U GET IT PICKUP AND DELIVERY ║ 1203 1005 ║ GEORGE HARPER WASHINGTON ║ 1204 ║ ║ ║ ║ ║ ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print) Alt G (Graph) F5 (Find Invoice) F6 (Find Name) F7 (Find Cusnum) F8 (Recalc Subtotal) Ctrl N (Add) Ctrl U (Delete) Alt M (Misc Routines) Alt S (Setup) KISBILL - Keep It Simple Billing and Invoicing System Page: 4 From the MAIN MENU you can: Press: Esc to exit to DOS F1 for a help screen F2 to edit the highlighted invoice header record (INVOICE.DBF) * F3 to browse/edit all detail items (DETAIL.DBF) F4 to print the highlighted invoice * Alt G to produce a on screen graph of the past 12 months of sales (press Print Scrn if you want a printout of it...) F5 to find an invoice based on the invoice number (INVOICE) F6 to find an invoice based on the customers name (NAME) F7 to find an invoice based on the customers number (CUSNUM) F8 to recalculate the subtotal in the header record. Useful whenever you might change/alter the detail records after creating the invoice * Ctrl N to create/add an invoice Ctrl U to delete an invoice. Does not delete the detail * Alt M to 'call up' the Miscellaneous Routines Alt S to view/edit the setup/configuration/defaults * Denotes special or important options ■ F1 - HELP SCREEN FOR BROWSE/DBEDIT (Applicable to any 'browse' screen) KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ ┌────────────────────────[ KISBIL HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │ - Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ │ │ └─────────────────────────────────────────────────────────────────────────────┘ Press any key to continue... KISBILL - Keep It Simple Billing and Invoicing System Page: 5 ■ F2 - Full screen editing of an invoice or detail record. KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ ┌───────────────────────────[ FULL SCREEN EDIT ]──────────────────────────────┐ │ INVOICE: 1004 │ │ NAME: George Martin Luther │ │ CUSNUM: 2355 │ │ ATTN: George │ │ ADDRESS1: PO Box 123 │ │ ADDRESS2: │ │ CITY: Winter Park │ │ STATE: Florida │ │ ZIP: 12345 │ │ PHONE: 123-5555 │ │ TERMS: NET 30 │ │ DATE: 11/05/89 │ │ BY: Tom │ │ CUST_PO: N/A │ │ TAX: T │ │ ADJUST: 12.00 │ │ FREIGHT: 5.00 │ │ SUBTOTAL: 0.00 │ │ COMMENT: The rest will arrive within the next 9 years... │ └─────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ ■ F3 - Browse/edit the detail records (DETAIL.DBF) KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ TJS LAB, PO BOX 5366, ORLANDO FL 32858 (Version B1.2) │S M T W T F S │ Invoice: 1000 259.62 ├────────────────────┤ Cu┌───────────────────[ BROWSE THE DETAIL RECORDS ]───────────────────────┐4│ │ INVOICE ITEM DESC QTY │1│ │─────────────╥────────────╥────────────────────────────────╥───────────│8│ │ 1000 ║ 2341234123 ║ SMALL JAR ║ 3 │5│ │ 1000 ║ SERVICE1 ║ ONSITE SETUP AND SERVICE ║ 4 │ │ │ 1001 ║ 1234567890 ║ RATHER LARGE JAR WITHOUT LIDDS ║ 3 │ │ C│ 1001 ║ SERVICE1 ║ ONSITE SETUP AND SERVICE ║ 3 │─┘ │ 1001 ║ SERVICE2 ║ OFFSITE SERVICE ║ 5 │ ────│ 1002 ║ 8383838838 ║ IGNORANT JAR ║ 2344 │── │ 1002 ║ SERVICE2 ║ OFFSITE SERVICE ║ 4 │ │ 1002 ║ DAYO12 ║ DAYO CONFIG SYSTEM & SOURCE ║ 1 │ │ 1003 ║ ADVICE ║ CONSULTATION ║ 234 │ │ 1005 ║ 1234567890 ║ RATHER LARGE JAR WITHOUT LIDDS ║ 10 │ │ 1005 ║ 2341234123 ║ SMALL JAR ║ 3 │ │ 1005 ║ 8383838838 ║ IGNORANT JAR ║ 4 │ └───────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) F2 (Edit) F5 (Find Invoice) F6 (Find Item) Ctrl N (Add) Ctrl U (Delete) KISBILL - Keep It Simple Billing and Invoicing System Page: 6 ■ Press F5,F6, or F7 to find an invoice or record based upon the index KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ TJS LAB, PO BOX 5366, ORLANDO FL 32858 (Version B1.2) │S M T W T F S │ Invoice: 1000 259.62 ├────────────────────┤ Customer Number: 1200 │ 1 2 3 4│ Date: 11/05/89 │ 5 6 7 8 9 10 11│ Name: HARPER BOOKS │12 13 14 15 16 17 18│ Attn: ACCOUNTS PAYABLE │19 20 21 22 23 24 25│ Phone: 393-5555 │26 27 28 29 30 │ Address1: │ │ City,State Zip: ORLANDO, FL34233-0393 └────────────────────┘ INVOICE NAME CUSNUM ──────────────────────╥────────────────────────────────╥─────────────────────── 1000 ║ HARPER BOOKS ║ 1200 1001 ║ EARL WOODS ║ 1201 ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: GEORGE │ └───────────────────────────────────────────────────TJS LAB───┘ ║ ║ ║ ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print) Alt G (Graph) F5 (Find Invoice) F6 (Find Name) F7 (Find Cusnum) F8 (Recalc Subtotal) Ctrl N (Add) Ctrl U (Delete) Alt M (Misc Routines) Alt S (Setup) 2/5 ■ Press Ctrl N to create/add a new invoice. You will be presented with a blank header record (INVOICE.DBF) to fill in ┌──────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]───────────────────┐ │ INVOICE: 2025 │ │ DATE: 11/05/89 │ │ │ │ NAME: YELLOW REEDS STORE │ │ CUSTOMER NUMBER: 1202 │ │ ATTENTION: HERMAN GREEN │ │ ADDRESS LINE 1: 1234 RED LANE │ │ ADDRESS LINE 2: SUITE BLUE 3 │ │ CITY: WINTER PARK │ │ STATE: FL │ │ ZIP: 39393 │ │ TELEPHONE: │ │ TERMS: COD │ │ SERVICED BY: Tom │ │ CUST_PO: None │ │ TAX: Y │ │ ADJUSTMENT: 100.00 │ │ FREIGHT: 0.00 │ │ │ │ COMMENT: Shipping you a red one instead of the blue... │ │ │ └─────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit KISBILL - Keep It Simple Billing and Invoicing System Page: 7 ■ After editing the header record, you will be prompted to add items to it. This can be done by pressing Ctrl N to add a blank line item, or F3 to recall a previously created line item. KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ ┌──────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]───────────────────┐ │ INVOICE: 1004 │ │ NAME: BIG BUSINESS STORE │ │ CUSNUM: 9393 │ │ ATTN: JORGE │ │ ADDRESS1: 939 VOLVELO ROAD │ │ ADDRESS2: │ │ CITY: ALTAMONTE SPRINGS │ │ STATE: FL │ ITEM DESCRIPTION QTY PRICE ─────────────────╥────────────────────────────────╥────────╥─────────────────── ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) F3 (Add From Detail) Ctrl N (Add) Ctrl U (Delete) <NONE> ■ F3 - Add a line item from previously created invoices: KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ ┌──────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]───────────────────┐ │ INVOICE: 1004 │ │ NAME:┌──────[ Select an Item to be added to this Invoice ]──────┐ │ │ CUSNU│ ITEM DESC PRICE │ │ │ ATTN:│────────────╥────────────────────────────────╥────────────│ │ │ ADDRE│ 1234567890 ║ RATHER LARGE JAR WITHOUT LIDDS ║ 100.11 │ │ │ ADDRE│ 1234567890 ║ RATHER LARGE JAR WITHOUT LIDDS ║ 100.11 │ │ │ CITY:│ 2341234123 ║ SMALL JAR ║ 34.03 │ │ │ STATE│ 2341234123 ║ SMALL JAR ║ 34.03 │ │ ITE│ 8383838838 ║ IGNORANT JAR ║ 29.34 │ ─────────│ 8383838838 ║ IGNORANT JAR ║ 29.34 │────────── SER│ ADVICE ║ CONSULTATION ║ 20.00 │00 │ DAYO12 ║ DAYO CONFIG SYSTEM & SOURCE ║ 49.00 │ └──────────────────────────────────────────────────────────┘ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Esc (Abort/Exit) Enter (Add Highlighted Item) F5/F6 (Find) ■ * Refunds are possible by entering in a negative quantity on the line item, or a negative amount in the ADJUST field on the header record. KISBILL - Keep It Simple Billing and Invoicing System Page: 8 ■ At each addition of a line item, you will be presented with the following screen: KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ ┌──────────────────[ ADD A NEW INVOICE - FULL SCREEN EDIT ]───────────────────┐ │ INVOICE: 1004 │ │ NAME:┌──────────────────────────────────────────────────────────┐ │ │ CUSNU│ Item: SERVICE1 │ │ │ ATTN:│ Description: ONSITE SETUP AND SERVICE │ │ │ ADDRE│ Price: 35.00.00 │ │ │ ADDRE│ │ │ │ CITY:│ Enter Qty: 1 │ │ │ STATE└──────────────────────────────────────────────────────────┘ │ ITEM DESCRIPTION QTY PRICE ─────────────────╥────────────────────────────────╥────────╥─────────────────── ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ Esc (Exit) F1 (Help) F2 (Edit) F3 (Add From Detail) Ctrl N (Add) Ctrl U (Delete) Press Esc to exit the browse/editing of line items for a new invoice ■ Alt G - Sales History Graph. This option will print onto the screen 2 reports. The first is a graph of the past 12 months of sales. The sum of each calendar month is calculated. DOES NOT INCLUDE any adjustments (ADJUST), freight (FREIGHT), or taxes. The data is derived solely from the PRICE*QTY (from the DETAIL.DBF), if not a deleted record. The second report is just the summary of the graph; a listing of each month, its total sales and numbers of items sold. To print either or both of these reports, just 'Print Screen'. The routine reindexes the DETAIL.DBF each time run (indexed on DATE). KISBILL - Keep It Simple Billing and Invoicing System Page: 9 ■ Graph Report #1: TJS LAB 11/05/89 SALES HISTORY, Past 12 Calendar Months ╔═══════════════════════════════════════════════════════════════════════╗ ║ ██▓▒░ ║ ║ ██▓▒░ ██▓▒░ ║ ║ ██▓▒░ ██▓▒░ ║ ║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██▓▒░ ██▓▒░ ██▓▒░ ██▓▒░║ ║ ██$▒░ ██$▒░ ██$▒░ ██$▒░║ ║ $ ██1▒░ ██1▒░ $ ██1▒░ ██$▒░ ██1▒░║ ║ $ $ $ $ 2 ██2▒░ ██0▒░ 5 ██3▒░ ██7▒░ ██0▒░║ ║ 1 8 8 8 0 ██4▒░ ██8▒░ 2 ██3▒░ ██5▒░ ██8▒░║ ║ 0 3 3 $ 2 7 ██0▒░ ██2▒░ ██0▒░ ██4▒░ ██6▒░ ██4▒░║ ║ 0 5 2 9 5 0 ██8▒░ ██7▒░ ██2▒░ ██5▒░ ██7▒░ ██9▒░║ ║ 0 7 3 3 0 3 ██5▒░ ██3▒░ ██7▒░ ██7▒░ ██0▒░ ██6▒░║ ║ 0 1 1 3 2 5 ██0▒░ ██6▒░ ██1▒░ ██6▒░ ██2▒░ ██3▒░║ ║ . . . . . . ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░║ ║ 0 1 1 0 1 ██4▒░ ██0▒░ ██1▒░ ██3▒░ ██1▒░ ██4▒░ ██0▒░║ ║ 0▒░ ██6▒░ ██6▒░ 0▒░ ██6▒░ ██0▒░ ██0▒░ ██6▒░ ██2▒░ ██6▒░ ██6▒░ ██8▒░║ ╟─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────╢ ║Dec88│Jan89│Feb89│Mar89│Apr89│May89│Jun89│Jul89│Aug89│Sep89│Oct89│Nov89║ ╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝ Total Dollars YTD: $6,487,372.06 Total Pieces: 2255 ■ Graph Report #2 (Summary): TJS LAB 11/05/89 SALES HISTORY, Past 12 Calendar Months ╔═══════════════════════════════════════════════════════════════════════╗ ║╔═[ Summary ]════════════════════════════════════════╗██▓▒░ ║ ║║ Month Year Total Sales Total Items║██▓▒░ ║ ║║ November 1989 $1,084,963.08 477 ║██▓▒░ ║ ║║ October 1989 $756,702.46 268 ║██▓▒░ ║ ║║ September 1989 $1,334,576.16 246 ║██▓▒░ ██▓▒░║ ║║ August 1989 $520,271.32 363 ║██▓▒░ ██▓▒░║ ║║ July 1989 $1,082,736.16 128 ║██▓▒░ ██▓▒░║ ║║ June 1989 $1,240,850.00 495 ║██$▒░ ██$▒░║ ║║ May 1989 $207,035.40 72 ║██1▒░ ██$▒░ ██1▒░║ ║║ April 1989 $82,502.16 27 ║██3▒░ ██7▒░ ██0▒░║ ║║ March 1989 $933.00 9 ║██3▒░ ██5▒░ ██8▒░║ ║║ February 1989 $83,231.16 30 ║██4▒░ ██6▒░ ██4▒░║ ║║ January 1989 $83,571.16 40 ║██5▒░ ██7▒░ ██9▒░║ ║║ December 1988 $10,000.00 100 ║██7▒░ ██0▒░ ██6▒░║ ║╚════════════════════════════════════════════════════╝██6▒░ ██2▒░ ██3▒░║ ║ . . . . . . ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░ ██.▒░║ ║ 0 1 1 0 1 ██4▒░ ██0▒░ ██1▒░ ██3▒░ ██1▒░ ██4▒░ ██0▒░║ ║ 0▒░ ██6▒░ ██6▒░ 0▒░ ██6▒░ ██0▒░ ██0▒░ ██6▒░ ██2▒░ ██6▒░ ██6▒░ ██8▒░║ ╟─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────┬─────╢ ║Dec88│Jan89│Feb89│Mar89│Apr89│May89│Jun89│Jul89│Aug89│Sep89│Oct89│Nov89║ ╚═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╧═════╝ Total Dollars YTD: $6,487,372.06 Total Pieces: 2255 KISBILL - Keep It Simple Billing and Invoicing System Page: 10 ■ F4 - When you press F4, a small menu appears on the screen giving you the option to print the highlighted invoice, or go to the REPORTS menu. ┌────────────────────────────────────────────────────────────────────────────┐ │ Invoice: 21 Customer: GEORGE HARPER WASHINGTON │ │ Select Option -> PRINT THIS INVOICE │ │ REPORTS MENU │ │ EXIT │ └────────────────────────────────────────────────────────────────────────────┘ ■ To print an invoice, simply press Enter again. You will then be prompted to enter the number of copies (if you have a laser printer) and then to press Enter to continue (Print). ┌────────────────────────────────────────────────────────────────────────────┐ │ Ready your Standard printer, then Press Enter to Start Printing... │ │ Press Esc now to abort... │ └────────────────────────────────────────────────────────────────────────────┘ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * The invoices print onto 8.5 by 11 inch paper at 6 lines per inch with approximately 66 lines per page. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ■ The HP printout will do much of the printer setup (ie:LPI & CPI), but no setup takes place on the standard printer. *** Note, the HP Laser invoice is more 'elaborate'. Sample of Standard Invoice Next Page. KISBILL - Keep It Simple Billing and Invoicing System Page: 11 ■ Sample printout of Invoice: Invoice: 1011 Page: 1 Date of Invoice: 11/05/89 Date Printed: 11/05/89 16:11:02 TJS LAB Attn: Accounts Receivable P.O. BOX 585366 Orlando, Florida 32858-5366 407-291-3960 Serviced by: TJ -------------------------------------------------------------------------- Customer: 1208 Terms: NET 10 FLOWERS WORLD Customer Po: JOSE Taxable: 0.060 15001 EAST RIVER ROAD SUITE 343 EATONVILLE, FL 93939 393-5555 Comments: I'm sending you a purple ones (out of gold, yellow, and blue) -------------------------------------------------------------------------- ITEM DESCRIPTION QTY PRICE EXTENDED ---------- ------------------------------ ------ ---------- ---------- REG909 RATHER LARGE JAR 4 34.00 136.00 *** Nothing Follows *** -------------------------------------------------------------------------- Sales Total: 136.00 Adjustments: 0.00 Freight/Other: 0.00 Subtotal: 136.00 Tax: 8.16 Net Total: 144.16 -------------------------- Paid:- 0.00 x Balance Due: 144.16 KISBILL - Keep It Simple Billing and Invoicing System Page: 12 ■ REPORTS MENU - There are 7 Report and 2 Label routines from the Reports Menu. All the reports will print to printer or file. A few of the options let you set the date range and select an index (ie: sorted on INVOICE, or NAME). Press 'Esc' or '10' to exit this menu... ┌────────────────────────────[ REPORTS MENU ]───────────────────────────┐ │ Select the REPORT option you desire: │ │ 1 - Header Invoice Report (With Date Range & Index Selection) │ │ 2 - Detail Invoice Report (With Date Range & Index Selection) │ │ 3 - Product/Item Listing (Unique ITEM) │ │ 4 - Product/Item Movement (With Date Range) │ │ 5 - Customers (Unique CUSNUM) │ │ 6 - Customers (Unique NAME) │ │ 7 - Address/Mailing Labels │ │ 8 - Folder Labels (CUSNUM, NAME) │ │ 9 - Open Invoices │ │ 10 - Exit │ └───────────────────────────────────────────────────────────────────────┘ ■ Report Forms - There are 5 report forms required: INVOICE.FRM - Used with options 1,9 DETAIL.FRM - Used with option 2 ITEM.FRM - Used with option 3 MOVEMENT.FRM - Used with option 4 CUSTOMER.FRM - Used with options 5,6 ■ 1 - Header Invoice Report (With Date Range & Index Selection) Use this report to list all your invoice header records (from the INVOICE.DBF). This report gives you the option to set the date range of invoices you want included on the report (from the DATE field in INVOICE.DBF). You can also select 1 of 3 indexes, type in any heading you want (just defaults to your company name), and tell it where you want the printout to go (printer or file). ┌───[ Header Invoice Report (With Date Range & Index Selection) ]─────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ Select Index: 1 1-Invoice 2-Name 3-Cusnum │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ * This report is 132 character wide... KISBILL - Keep It Simple Billing and Invoicing System Page: 13 ■ 2 - Detail Invoice Report (With Date Range & Index Selection) Use this report to list all your invoice detail records (from the DETAIL.DBF). This report has the same options as the 1st report. ┌───[ Detail Invoice Report (With Date Range & Index Selection) ]─────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ Select Index: 1 1-Invoice 2-Item │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ ■ Example of the Detail Invoice Report: Page No. 1 TJS LAB 11/11/89 INVOICE DETAIL EXTENDED INVOICE ITEM DESCRIPTION QTY PRICE TOTAL -------- ---------- ------------------------------ ----- ---------- ---------- 1 MISSILE1 3MT BOMB 1 102.00 102.00 121 MG34 MACHINE GUNS MODEL 34LLD 1 643.00 643.00 141 PISTOL3 PISTOL MODEL III 1 243.00 243.00 156 REG909 RATHER LARGE CARPET 45 10.00 450.00 334 REG909 RATHER LARGE CARPET 2 10.00 20.00 465 REG909 RATHER LARGE CARPET 2 10.00 20.00 677 REG909 RATHER LARGE CARPET 2 10.00 20.00 ■ 3 - Product/Item Listing Use this report to list all 'unique' items in your DETAIL.DBF. This report has only 2 options; the Heading and printing to printer or file. The index is on ITEM. ┌───────────────────────[ Product/Item Listing ]──────────────────────┐ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ ■ Example of the Product/Item Report next page... KISBILL - Keep It Simple Billing and Invoicing System Page: 14 ■ Example of the Product/Item Report Page No. 1 TJS LAB 11/11/89 PRODUCT/ITEM REPORT ITEM DESCRIPTION PRICE REMARKS ---------- ------------------------------ ---------- ------------------------ 1 Jar 34.30 ________________________ 2 Big Jar 3.24 ________________________ 3 Little Jar 243.00 ________________________ 5Y Yellow Jar 170.99 ________________________ 6 Missing Jar 433.34 ________________________ 8 Wide Mouth Jar 33.00 ________________________ 9 2 Mouth Jar 334.00 ________________________ 10 3 Sided Jar 99.99 ________________________ ■ 4 - Detail Product/Item Movement (With Date Range) Use this report to determine how much of each unique ITEM you have sold in any date range. The index is on ITEM. ┌─────────[ Detail Product/Item Movement (With Date Range) ]──────────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ └─────────────────────────────────────────────────────────────────────┘ ■ Example of the Product/Item Movement Report: Page No. 1 TJS LAB 11/11/89 PRODUCT/ITEM MOVEMENT REPORT EXTENDED INVOICE QTY PRICE TOTAL -------- ----- ---------- ---------- ** ITEM: 1 DESCRIPTION: 1928 CAR 121 1 12102.00 12102.00 ** Subtotal ** 1 12102.00 ** ITEM: 1020RED DESCRIPTION: RED ROOSTER 20 3 34.00 102.00 21 3 34.00 102.00 2018 43 34.00 1462.00 ** Subtotal ** 49 1664.00 KISBILL - Keep It Simple Billing and Invoicing System Page: 15 ■ 5 & 6 - Customers (Unique CUSNUM & NAME) Use these 2 reports to create a list of all your active customers. Will print only one record (from the INVOICE.DBF) for each unique CUSNUM and/or NAME. The index in on CUSNUM for option 5, on NAME for option 6. ┌───────────────────[ Customers (Unique CUSNUM) ]─────────────────────┐ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ ┌────────────────────[ Customers (Unique NAME) ]──────────────────────┐ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ ■ Example of the Customers List: Page No. 1 TJS LAB 11/11/89 CUSTOMERS --------- PHONE TERMS CUSNUM NAME & ADDRESS DATE REMARKS -------- ------------------------------ -------------- -------------------- 1202 YELLOW REEDS STORE 342-5555 ____________________ HERMAN GREEN COD 1234 RED LANE 11/05/89 SUITE BLUE 3 WINTER PARK, FL 39393 1203 U GET IT PICKUP AND DELIVERY 304-5555 ____________________ JOE CASH 123 BEAUMONT DRIVE 11/15/87 ORLANDO, FL 39393 1208 FLOWERS WORLD 393-5555 ____________________ JOSE NET 10 15001 EAST RIVER ROAD 10/05/88 SUITE 343 EATONVILLE, FL 93939 1204 GEORGE HARPER WASHINGTON 291-3960 ____________________ Georgy NET 30 24W Minister Road 11/23/89 Harper St Winter Park, fl 2343 33 KISBILL - Keep It Simple Billing and Invoicing System Page: 16 ■ 7 - Address and Mailing Labels. Use this option to print address or mailing labels onto the standard label (3.5 inches by 15/16 inches) Mount the labels into your printer, and when ready, just press Enter on the selected Invoice/Customer record to print it. Those records that have been printed will be displayed at the top of the screen. Print as many as you want. KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ TJS LAB, PO BOX 5366, ORLANDO FL 32858 (Version B1.2) │S M T W T F S │ Invoi┌───────────────────────────────────────┐ ├────────────────────┤ Customer Numb│ 3 GEORGE HARPER WASHINGTON │ │ 1 2 3 4│ Da│ 4 GEORGE HARPER WASHINGTON │ │ 5 6 7 8 9 10 11│ ┌────────────│ 5 YELLOW REEDS STORE │──────────────────┐ 18│ │ Select the │ 6 FLOWERS WORLD │ │ 25│ │ 1 - Header│ 7 EARL WOODS │Selection) │ │ ┌─│ 2 - Detail└───────────────────────────────────────┘Selection) │──┐│ │ │ ┌────────────────────[ ADDRESS & MAILING LABELS ]─────────────────────┐ │┘ │ │ │ INVOICE NAME CUSNUM │ │ │ │ │─────────────────╥────────────────────────────────╥──────────────────│ │─ │ │ │ 2019 ║ EARL WOODS ║ 1201 │ │ └─│ │ 2021 ║ HARPER BOOKS ║ 1200 │──┘ │ │ 2022 ║ ASDKJFDASKFDSA ║ 1204 │ │ │ 2024 ║ GEORGE HARPER WASHINGTON ║ 1204 │ │ │ 2025 ║ YELLOW REEDS STORE ║ 1202 │ └─│ 2026 ║ SDF ║ 324 │ ├─────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Enter (Print Highlighted Label) F5,F6,F7 (Find) │ └─────────────────────────────────────────────────────────────────────┘ Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print) Alt G (Graph) F5 (Find Invoice) F6 (Find Name) F7 (Find Cusnum) F8 (Recalc Subtotal) Ctrl N (Add) Ctrl U (Delete) Alt M (Misc Routines) Alt S (Setup) 31/45 ■ Example of Address/Mailing Labels: │■│┌─────────────────────────────────────┐│■│ │■││ YELLOW REEDS STORE ││■│ │■││ HERMAN GREEN ││■│ │■││ 1234 RED LANE ││■│ │■││ SUITE BLUE 3 ││■│ │■││ WINTER PARK, FL 39393 ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ │■││ EARL WOODS ││■│ │■││ PO BOX 3432-5555 ││■│ │■││ ORLANDO, FL 23434 ││■│ │■││ ││■│ │■││ ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ KISBILL - Keep It Simple Billing and Invoicing System Page: 17 ■ 8 - Folder Labels (CUSNUM, NAME). Use this option to print labels to attach atop manilla file folders. This option is the same as option 7, except that that different data is printed onto the label. The CUSNUM, NAME, PHONE, and CITY, STATE, ZIP are printed. ■ Example of Folder Labels: │■│┌─────────────────────────────────────┐│■│ │■││ 50332 ││■│ │■││ HERMAN GREEN ││■│ │■││ 407-291-6987 ││■│ │■││ ORLANDO, FL 34323 ││■│ │■││ ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ │■││ 8393 ││■│ │■││ EARL WOODS ││■│ │■││ 504-234-2303 ││■│ │■││ WINTER PARK, FL 34222 ││■│ │■││ ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ ■ 9 - Open Invoice Report (With Date Range & Index Selection) This report is identical to option 1, except that it only prints out records (from the INVOICE.DBF) that have the OPEN field marked .T. *** Note that this report is 132 columns wide... ┌────[ Open Invoice Report (With Date Range & Index Selection) ]──────┐ │ Start Date: 10/12/89 │ │ End Date: 11/11/89 │ │ Select Index: 1 1-Invoice 2-Name 3-Cusnum │ │ Heading: TJS LAB │ │ Printer or File: 1 1-Printer 2-File │ │ │ └─────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 18 ■ Alt M - MISCELLANEOUS ROUTINES KISBILL - KEEP IT SIMPLE BILLING & INVOICING PROGRAM ┌───[November 1989]──┐ TJS LAB, PO BOX 5366, ORLANDO FL 32858 (Version B1.2) │S M T W T F S │ Invoice: 1000 259.62 ├────────────────────┤ Customer Number: 1200 │ 1 2 3 4│ Date: 11/05/89 ┌─────────────────┐ │ 5 6 7 8 9 10 11│ Name: HARPER BOOKS │APPEND FROM │ │12 13 14 15 16 17 18│ Attn: ACCOUNTS PAYA│BROWSE DATABASES │ │19 20 21 22 23 24 25│ Phone: 393-5555 │COPY (.DBF) TO │ │26 27 28 29 30 │ Address1: │CREATE DATABASE │ │ │ City,State Zip: ORLANDO, FL34│DELETE RECORDS │ └────────────────────┘ INVOICE NAME │ERASE FILE │ CUSNUM ──────────────────────╥─────────│EXIT TO DOS │────╥─────────────────────── 1000 ║ HARPER B│INDEX A DATABASE │ ║ 1200 1001 ║ EARL WOO│LIST FIELDS │ ║ 1201 1002 ║ YELLOW R│PACK DATABASE │ ║ 1202 1003 ║ U GET IT│MODIFY DATABASE │Y ║ 1203 1004 ║ BIG BUSI│RECALL RECORDS │ ║ 9393 1005 ║ GEORGE H│RETURN TO MENU │ ║ 1204 ║ │RUN (DOS COMMAND)│ ║ ║ └─────────────────┘ ║ Esc (Exit) F1 (Help) F2 (Edit) F3 (Detail) F4 (Print) Alt G (Graph) F5 (Find Invoice) F6 (Find Name) F7 (Find Cusnum) F8 (Recalc Subtotal) Ctrl N (Add) Ctrl U (Delete) Alt M (Misc Routines) Alt S (Setup) - The backdoor routines is a collection of 18 very useful Database Management Routines. These routines provide you with 'ability to do whatever was left out of the rest of the program...' APPEND FROM PACK DATABASE BROWSE DATABASES MODIFY DATABASE COPY (.DBF) TO RECALL RECORDS CREATE DATABASE RETURN TO MENU DELETE RECORDS RUN (DOS COMMAND) ERASE FILE SIMPLE EDITOR EXIT TO DOS SORT DATABASE INDEX A DATABASE TYPE (PRINT) FILE LIST FIELDS ZAP DATABASE ******************************************************************************* - APPEND FROM - Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). - The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]────────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └─────────────────────────────────────────────────────────────────────────────┘ - if it exists in the current directory, press enter on an empty prompt to display all databases to select from. KISBILL - Keep It Simple Billing and Invoicing System Page: 19 ┌──────────────────────────────[ APPEND FROM ]────────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌────────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press ││ │ │ Enter/Return. ││ │ └────────────────────────┘│ │ │ └─────────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. KISBILL - Keep It Simple Billing and Invoicing System Page: 20 ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ******************************************************************************* - BROWSE DATABASES - Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... KISBILL - Keep It Simple Billing and Invoicing System Page: 21 - An example of a browse screen: TJS LAB, PO BOX 5366, ORLANDO FL 32858 ┌────────────────────────────────[ BROWSE SDF ]───────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥────────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨────────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └─────────────────────────────────────────────────────────────────────────────┘ 51/60 - To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! TJS LAB, PO BOX 5366, ORLANDO FL 32858 ┌────────────────────────────────[ BROWSE SDF ]───────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥──────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ───────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]──────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └─────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 22 - Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... ******************************************************************************* - COPY (.DBF) TO - Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. It can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]──────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌────────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press ││ │ │ Enter/Return. ││ │ └────────────────────────┘│ └─────────────────────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 23 - The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └─────────────────────────────────────────────────────────────────────────────┘ - The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). - The next prompt (if used), requires some knowledge of dBase (tm). It is optional though. This prompt is requesting the user to to enter a condition or filter. If all records are to be copied, the just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚═══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └─────────────────────────────────────────────────────────────────────────────┘ - This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as depicted below) is fine... KISBILL - Keep It Simple Billing and Invoicing System Page: 24 ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚═══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └─────────────────────────────────────────────────────────────────────────────┘ - The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚═══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └─────────────────────────────────────────────────────────────────────────────┘ ******************************************************************************* - CREATE DATABASE - Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a "C" for character, "N" for numeric, "D" for Date, "L" for logical or "M" for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. KISBILL - Keep It Simple Billing and Invoicing System Page: 25 ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ ******************************************************************************* - DELETE RECORDS - Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: KISBILL - Keep It Simple Billing and Invoicing System Page: 26 ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ - After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records deleted will be displayed upon the screen as depicted just above... KISBILL - Keep It Simple Billing and Invoicing System Page: 27 ******************************************************************************* - ERASE FILE - Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... - The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - To ERASE a file, just highlight it, then press Enter... ******************************************************************************* - EXIT TO DOS - This option will close all open files and databases and exit to DOS without having to return the main menu exit routine. ******************************************************************************* - INDEX A DATABASE - You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. KISBILL - Keep It Simple Billing and Invoicing System Page: 28 ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ - You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ - At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ******************************************************************************* - LIST FIELDS - List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the KISBILL - Keep It Simple Billing and Invoicing System Page: 29 database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ - The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ - A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. KISBILL - Keep It Simple Billing and Invoicing System Page: 30 ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │════════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌─────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └─────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ - The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │═══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌─────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └─────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ - At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │═══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘──┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └─────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 31 - The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ******************************************************************************* - MODIFY DATABASE - Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a "C" for character, "N" for numeric, "D" for Date, "L" for logical or "M" for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** KISBILL - Keep It Simple Billing and Invoicing System Page: 32 *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ******************************************************************************* - PACK DATABASE - Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 33 ******************************************************************************* - RECALL RECORDS - Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ******************************************************************************* - RETURN TO MENU - Returns to the procedure that called MISC Routines. ******************************************************************************* - RUN (DOS COMMAND) - Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ - One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ - Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBILL>EXIT ******************************************************************************* - SIMPLE EDITOR - A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities, or 50,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. KISBILL - Keep It Simple Billing and Invoicing System Page: 34 ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. - If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]──────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └─────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 - Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit KISBILL - Keep It Simple Billing and Invoicing System Page: 35 The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ******************************************************************************* - SORT DATABASE - This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the sort field (limited to 1 field)... KISBILL - Keep It Simple Billing and Invoicing System Page: 36 ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ******************************************************************************* - TYPE (PRINT) FILE - Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBILL.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ - The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... KISBILL - Keep It Simple Billing and Invoicing System Page: 37 ******************************************************************************* - ZAP DATABASE - Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ KISBILL - Keep It Simple Billing and Invoicing System Page: 38 ORDER FORM: KISBILL Keep It Simple Billing & Invoicing System TJS LAB Attn: KIS SALES - TJB1 P.O. Box 585366 Orlando, Florida 32858-5366 For the cost of registering/licensing this Shareware Software, you will receive the same program with more enhancements and a module containing report and label printing. Any updates will also be included upon registration. A Source Code License is also granted as part of registration (You get the Clipper Source Code). To modify the code requires Clipper 87 (tm) by Nantucket. A SOURCE CODE LICENSE means you have the right to use & modify the source codes for your personal/business/network needs, but no rights to resell any part of it without the prior written consent of TJS LAB. COST QTY ------ ----- KISBILL Registration & License...................... $25.00 _____ TOTAL: __________ ┌───────────────────────────────────┐ Check or Money Order Only Please. │ Note: The Registration Copy will │ --------------------------------- │ be mailed to you on a 5.25 floppy │ └───────────────────────────────────┘ Print Your Name and Address Clearly... Mail To: Name: _______________________________ TJS LAB Address: _______________________________ Attn: KIS-SDN PO BOX 585366 _______________________________ Orlando, Florida 32858-5366 _______________________________ Look for KISBILL's big _______________________________ brother: DAYO Any Special Instructions/Comments? (Please!) ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________ ____________________________________________________________________________